package cn.mysdp.biz.domain;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.annotation.JSONField;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonProperty;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * InterfaceName: SdpWorkspaceExample
 * @Description:
 * @Author: SDP
 * @Date: 2021-10-30
 * @Version: 1.0
 * Table: sdp_workspace
 * Comment:
 * workspace
 */
public class SdpWorkspaceExample extends BaseExample {
    protected CriteriaString setNull;

    protected List<Criteria> oredCriteria = new ArrayList<>();

    public CriteriaString getSetNull() {
        return setNull;
    }

    public void setSetNull(CriteriaString setNull) {
        this.setNull = setNull;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public static SdpWorkspaceExample createExample(SdpWorkspaceWithBLOBs request) throws Exception {
        return createExample(request, null);
    }

    public static SdpWorkspaceExample createExample(SdpWorkspaceWithBLOBs request, JSONObject options) throws Exception {
        SdpWorkspaceExample example = new SdpWorkspaceExample();
        SdpWorkspaceExample.Criteria criteria = example.createCriteria();

        example.fixExample(SdpWorkspaceWithBLOBs.class, CriteriaString.class, criteria, options);

        example.fixExample("EqualTo", 1, request, criteria);        

        if (options != null) {
            String orderBy = "";
            if (options.containsKey("order_by")) {
                orderBy = setCriteriaOrderBy(options.getJSONArray("order_by"), example);
                if (orderBy.length() > 0) {
                    example.setOrderByClause(orderBy);
                }
            }
        }

        return example;
    }

    private static String setCriteriaOrderBy(JSONArray jsonArray, SdpWorkspaceExample example) throws Exception {
        List<Object> request = Criterion.toList(jsonArray, CriteriaString.class);
        StringBuilder sb = new StringBuilder();
        int count = 0;
        for(int i = 0; i < request.size(); i++) {
            Object criteriaOrderByObj  = request.get(i);
            CriteriaString criteriaOrderBy = (CriteriaString)criteriaOrderByObj;
            int subCount = 0;

            subCount += appendCriteriaOrderByItem(sb, "id", criteriaOrderBy.getId());
            subCount += appendCriteriaOrderByItem(sb, "`name`", criteriaOrderBy.getName());
            subCount += appendCriteriaOrderByItem(sb, "root_path", criteriaOrderBy.getRootPath());
            subCount += appendCriteriaOrderByItem(sb, "db_host", criteriaOrderBy.getDbHost());
            subCount += appendCriteriaOrderByItem(sb, "db_port", criteriaOrderBy.getDbPort());
            subCount += appendCriteriaOrderByItem(sb, "db_database", criteriaOrderBy.getDbDatabase());
            subCount += appendCriteriaOrderByItem(sb, "db_username", criteriaOrderBy.getDbUsername());
            subCount += appendCriteriaOrderByItem(sb, "db_password", criteriaOrderBy.getDbPassword());
            subCount += appendCriteriaOrderByItem(sb, "db_classname", criteriaOrderBy.getDbClassname());
            subCount += appendCriteriaOrderByItem(sb, "db_jdbcurl", criteriaOrderBy.getDbJdbcurl());
            subCount += appendCriteriaOrderByItem(sb, "remark", criteriaOrderBy.getRemark());
            subCount += appendCriteriaOrderByItem(sb, "extra_info", criteriaOrderBy.getExtraInfo());
            if (subCount > 1) {
                throw new Exception("order by数组元素对象属性多于1个(SdpWorkspaceExample):"+count+","+JSON.toJSONString(jsonArray.get(i)));
            }
            if (subCount == 0 && !"{}".equals(JSON.toJSONString(jsonArray.get(i)))) {
                throw new Exception("存在非法order by 字段(SdpWorkspaceExample):"+count+","+JSON.toJSONString(jsonArray.get(i)));
            }
            count++;
        }
        if (sb.length() == 0) {
            appendCriteriaOrderByItem(sb, "1", "");
        }

        return sb.toString();
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("`name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("`name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("`name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("`name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("`name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("`name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("`name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("`name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameRegexp(String value) {
            addCriterion("`name` regexp", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("`name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("`name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("`name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("`name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("`name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("`name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andRootPathIsNull() {
            addCriterion("root_path is null");
            return (Criteria) this;
        }

        public Criteria andRootPathIsNotNull() {
            addCriterion("root_path is not null");
            return (Criteria) this;
        }

        public Criteria andRootPathEqualTo(String value) {
            addCriterion("root_path =", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathNotEqualTo(String value) {
            addCriterion("root_path <>", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathGreaterThan(String value) {
            addCriterion("root_path >", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathGreaterThanOrEqualTo(String value) {
            addCriterion("root_path >=", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathLessThan(String value) {
            addCriterion("root_path <", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathLessThanOrEqualTo(String value) {
            addCriterion("root_path <=", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathRegexp(String value) {
            addCriterion("root_path regexp", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathLike(String value) {
            addCriterion("root_path like", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathNotLike(String value) {
            addCriterion("root_path not like", value, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathIn(List<String> values) {
            addCriterion("root_path in", values, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathNotIn(List<String> values) {
            addCriterion("root_path not in", values, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathBetween(String value1, String value2) {
            addCriterion("root_path between", value1, value2, "rootPath");
            return (Criteria) this;
        }

        public Criteria andRootPathNotBetween(String value1, String value2) {
            addCriterion("root_path not between", value1, value2, "rootPath");
            return (Criteria) this;
        }

        public Criteria andDbHostIsNull() {
            addCriterion("db_host is null");
            return (Criteria) this;
        }

        public Criteria andDbHostIsNotNull() {
            addCriterion("db_host is not null");
            return (Criteria) this;
        }

        public Criteria andDbHostEqualTo(String value) {
            addCriterion("db_host =", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostNotEqualTo(String value) {
            addCriterion("db_host <>", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostGreaterThan(String value) {
            addCriterion("db_host >", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostGreaterThanOrEqualTo(String value) {
            addCriterion("db_host >=", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostLessThan(String value) {
            addCriterion("db_host <", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostLessThanOrEqualTo(String value) {
            addCriterion("db_host <=", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostRegexp(String value) {
            addCriterion("db_host regexp", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostLike(String value) {
            addCriterion("db_host like", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostNotLike(String value) {
            addCriterion("db_host not like", value, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostIn(List<String> values) {
            addCriterion("db_host in", values, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostNotIn(List<String> values) {
            addCriterion("db_host not in", values, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostBetween(String value1, String value2) {
            addCriterion("db_host between", value1, value2, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbHostNotBetween(String value1, String value2) {
            addCriterion("db_host not between", value1, value2, "dbHost");
            return (Criteria) this;
        }

        public Criteria andDbPortIsNull() {
            addCriterion("db_port is null");
            return (Criteria) this;
        }

        public Criteria andDbPortIsNotNull() {
            addCriterion("db_port is not null");
            return (Criteria) this;
        }

        public Criteria andDbPortEqualTo(Integer value) {
            addCriterion("db_port =", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortNotEqualTo(Integer value) {
            addCriterion("db_port <>", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortGreaterThan(Integer value) {
            addCriterion("db_port >", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortGreaterThanOrEqualTo(Integer value) {
            addCriterion("db_port >=", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortLessThan(Integer value) {
            addCriterion("db_port <", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortLessThanOrEqualTo(Integer value) {
            addCriterion("db_port <=", value, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortIn(List<Integer> values) {
            addCriterion("db_port in", values, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortNotIn(List<Integer> values) {
            addCriterion("db_port not in", values, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortBetween(Integer value1, Integer value2) {
            addCriterion("db_port between", value1, value2, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbPortNotBetween(Integer value1, Integer value2) {
            addCriterion("db_port not between", value1, value2, "dbPort");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseIsNull() {
            addCriterion("db_database is null");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseIsNotNull() {
            addCriterion("db_database is not null");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseEqualTo(String value) {
            addCriterion("db_database =", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseNotEqualTo(String value) {
            addCriterion("db_database <>", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseGreaterThan(String value) {
            addCriterion("db_database >", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseGreaterThanOrEqualTo(String value) {
            addCriterion("db_database >=", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseLessThan(String value) {
            addCriterion("db_database <", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseLessThanOrEqualTo(String value) {
            addCriterion("db_database <=", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseRegexp(String value) {
            addCriterion("db_database regexp", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseLike(String value) {
            addCriterion("db_database like", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseNotLike(String value) {
            addCriterion("db_database not like", value, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseIn(List<String> values) {
            addCriterion("db_database in", values, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseNotIn(List<String> values) {
            addCriterion("db_database not in", values, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseBetween(String value1, String value2) {
            addCriterion("db_database between", value1, value2, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbDatabaseNotBetween(String value1, String value2) {
            addCriterion("db_database not between", value1, value2, "dbDatabase");
            return (Criteria) this;
        }

        public Criteria andDbUsernameIsNull() {
            addCriterion("db_username is null");
            return (Criteria) this;
        }

        public Criteria andDbUsernameIsNotNull() {
            addCriterion("db_username is not null");
            return (Criteria) this;
        }

        public Criteria andDbUsernameEqualTo(String value) {
            addCriterion("db_username =", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameNotEqualTo(String value) {
            addCriterion("db_username <>", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameGreaterThan(String value) {
            addCriterion("db_username >", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("db_username >=", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameLessThan(String value) {
            addCriterion("db_username <", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameLessThanOrEqualTo(String value) {
            addCriterion("db_username <=", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameRegexp(String value) {
            addCriterion("db_username regexp", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameLike(String value) {
            addCriterion("db_username like", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameNotLike(String value) {
            addCriterion("db_username not like", value, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameIn(List<String> values) {
            addCriterion("db_username in", values, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameNotIn(List<String> values) {
            addCriterion("db_username not in", values, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameBetween(String value1, String value2) {
            addCriterion("db_username between", value1, value2, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbUsernameNotBetween(String value1, String value2) {
            addCriterion("db_username not between", value1, value2, "dbUsername");
            return (Criteria) this;
        }

        public Criteria andDbPasswordIsNull() {
            addCriterion("db_password is null");
            return (Criteria) this;
        }

        public Criteria andDbPasswordIsNotNull() {
            addCriterion("db_password is not null");
            return (Criteria) this;
        }

        public Criteria andDbPasswordEqualTo(String value) {
            addCriterion("db_password =", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordNotEqualTo(String value) {
            addCriterion("db_password <>", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordGreaterThan(String value) {
            addCriterion("db_password >", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("db_password >=", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordLessThan(String value) {
            addCriterion("db_password <", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordLessThanOrEqualTo(String value) {
            addCriterion("db_password <=", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordRegexp(String value) {
            addCriterion("db_password regexp", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordLike(String value) {
            addCriterion("db_password like", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordNotLike(String value) {
            addCriterion("db_password not like", value, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordIn(List<String> values) {
            addCriterion("db_password in", values, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordNotIn(List<String> values) {
            addCriterion("db_password not in", values, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordBetween(String value1, String value2) {
            addCriterion("db_password between", value1, value2, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbPasswordNotBetween(String value1, String value2) {
            addCriterion("db_password not between", value1, value2, "dbPassword");
            return (Criteria) this;
        }

        public Criteria andDbClassnameIsNull() {
            addCriterion("db_classname is null");
            return (Criteria) this;
        }

        public Criteria andDbClassnameIsNotNull() {
            addCriterion("db_classname is not null");
            return (Criteria) this;
        }

        public Criteria andDbClassnameEqualTo(String value) {
            addCriterion("db_classname =", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameNotEqualTo(String value) {
            addCriterion("db_classname <>", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameGreaterThan(String value) {
            addCriterion("db_classname >", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameGreaterThanOrEqualTo(String value) {
            addCriterion("db_classname >=", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameLessThan(String value) {
            addCriterion("db_classname <", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameLessThanOrEqualTo(String value) {
            addCriterion("db_classname <=", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameRegexp(String value) {
            addCriterion("db_classname regexp", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameLike(String value) {
            addCriterion("db_classname like", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameNotLike(String value) {
            addCriterion("db_classname not like", value, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameIn(List<String> values) {
            addCriterion("db_classname in", values, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameNotIn(List<String> values) {
            addCriterion("db_classname not in", values, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameBetween(String value1, String value2) {
            addCriterion("db_classname between", value1, value2, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbClassnameNotBetween(String value1, String value2) {
            addCriterion("db_classname not between", value1, value2, "dbClassname");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlIsNull() {
            addCriterion("db_jdbcurl is null");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlIsNotNull() {
            addCriterion("db_jdbcurl is not null");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlEqualTo(String value) {
            addCriterion("db_jdbcurl =", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlNotEqualTo(String value) {
            addCriterion("db_jdbcurl <>", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlGreaterThan(String value) {
            addCriterion("db_jdbcurl >", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlGreaterThanOrEqualTo(String value) {
            addCriterion("db_jdbcurl >=", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlLessThan(String value) {
            addCriterion("db_jdbcurl <", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlLessThanOrEqualTo(String value) {
            addCriterion("db_jdbcurl <=", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlRegexp(String value) {
            addCriterion("db_jdbcurl regexp", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlLike(String value) {
            addCriterion("db_jdbcurl like", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlNotLike(String value) {
            addCriterion("db_jdbcurl not like", value, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlIn(List<String> values) {
            addCriterion("db_jdbcurl in", values, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlNotIn(List<String> values) {
            addCriterion("db_jdbcurl not in", values, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlBetween(String value1, String value2) {
            addCriterion("db_jdbcurl between", value1, value2, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andDbJdbcurlNotBetween(String value1, String value2) {
            addCriterion("db_jdbcurl not between", value1, value2, "dbJdbcurl");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkRegexp(String value) {
            addCriterion("remark regexp", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andExtraInfoIsNull() {
            addCriterion("extra_info is null");
            return (Criteria) this;
        }

        public Criteria andExtraInfoIsNotNull() {
            addCriterion("extra_info is not null");
            return (Criteria) this;
        }

        public Criteria andExtraInfoEqualTo(String value) {
            addCriterion("extra_info =", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoNotEqualTo(String value) {
            addCriterion("extra_info <>", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoGreaterThan(String value) {
            addCriterion("extra_info >", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoGreaterThanOrEqualTo(String value) {
            addCriterion("extra_info >=", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoLessThan(String value) {
            addCriterion("extra_info <", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoLessThanOrEqualTo(String value) {
            addCriterion("extra_info <=", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoRegexp(String value) {
            addCriterion("extra_info regexp", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoLike(String value) {
            addCriterion("extra_info like", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoNotLike(String value) {
            addCriterion("extra_info not like", value, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoIn(List<String> values) {
            addCriterion("extra_info in", values, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoNotIn(List<String> values) {
            addCriterion("extra_info not in", values, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoBetween(String value1, String value2) {
            addCriterion("extra_info between", value1, value2, "extraInfo");
            return (Criteria) this;
        }

        public Criteria andExtraInfoNotBetween(String value1, String value2) {
            addCriterion("extra_info not between", value1, value2, "extraInfo");
            return (Criteria) this;
        }

    }

    public static class CriteriaString {
        //id
        @JsonProperty("id")
        @JSONField(name = "id")
        private String id;

        public String getId() {
            return id;
        }
    
        public void setId(String _v) {
            id = _v;
        }

        //name
        @JsonProperty("name")
        @JSONField(name = "name")
        private String name;

        public String getName() {
            return name;
        }
    
        public void setName(String _v) {
            name = _v;
        }

        //root_path
        @JsonProperty("root_path")
        @JSONField(name = "root_path")
        private String rootPath;

        public String getRootPath() {
            return rootPath;
        }
    
        public void setRootPath(String _v) {
            rootPath = _v;
        }

        //db_host
        @JsonProperty("db_host")
        @JSONField(name = "db_host")
        private String dbHost;

        public String getDbHost() {
            return dbHost;
        }
    
        public void setDbHost(String _v) {
            dbHost = _v;
        }

        //db_port
        @JsonProperty("db_port")
        @JSONField(name = "db_port")
        private String dbPort;

        public String getDbPort() {
            return dbPort;
        }
    
        public void setDbPort(String _v) {
            dbPort = _v;
        }

        //db_database
        @JsonProperty("db_database")
        @JSONField(name = "db_database")
        private String dbDatabase;

        public String getDbDatabase() {
            return dbDatabase;
        }
    
        public void setDbDatabase(String _v) {
            dbDatabase = _v;
        }

        //db_username
        @JsonProperty("db_username")
        @JSONField(name = "db_username")
        private String dbUsername;

        public String getDbUsername() {
            return dbUsername;
        }
    
        public void setDbUsername(String _v) {
            dbUsername = _v;
        }

        //db_password
        @JsonProperty("db_password")
        @JSONField(name = "db_password")
        private String dbPassword;

        public String getDbPassword() {
            return dbPassword;
        }
    
        public void setDbPassword(String _v) {
            dbPassword = _v;
        }

        //db_classname
        @JsonProperty("db_classname")
        @JSONField(name = "db_classname")
        private String dbClassname;

        public String getDbClassname() {
            return dbClassname;
        }
    
        public void setDbClassname(String _v) {
            dbClassname = _v;
        }

        //db_jdbcurl
        @JsonProperty("db_jdbcurl")
        @JSONField(name = "db_jdbcurl")
        private String dbJdbcurl;

        public String getDbJdbcurl() {
            return dbJdbcurl;
        }
    
        public void setDbJdbcurl(String _v) {
            dbJdbcurl = _v;
        }

        //remark
        @JsonProperty("remark")
        @JSONField(name = "remark")
        private String remark;

        public String getRemark() {
            return remark;
        }
    
        public void setRemark(String _v) {
            remark = _v;
        }

        //extra_info
        @JsonProperty("extra_info")
        @JSONField(name = "extra_info")
        private String extraInfo;

        public String getExtraInfo() {
            return extraInfo;
        }
    
        public void setExtraInfo(String _v) {
            extraInfo = _v;
        }

    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }
}
